CREATE  VIEW [dbo].[vWorkItemQueueReport]
AS

SELECT     wiq.WorkItemQueueKey,
    wiq.WorkflowInstanceKey,
    wiq.Category,
           CASE wiq.Priority WHEN 0 THEN 'Lowest' WHEN 1 THEN 'Below Normal' WHEN 2 THEN 'Normal' WHEN 3 THEN 'Above Normal' ELSE 'Highest' END Priority,
           CASE wiq.IsInteractive WHEN 0 THEN 'Non-visual' ELSE 'Interactive' END IsInteractive,
    wiq.Description,
    wiq.EnqueuedOn,
    COALESCE (wiq.BeginOn, getdate()) BeginOn,
    wiq.PerformerKey,
           COALESCE (cm.FullName, ins.InstituteName, gm.Name, '') PerformerName,
    ctr.ContactTypeDesc,
    wiq.RecoveryPoint,
    wiq.SelectionLock,
           CASE WHEN wiq.SelectionLock IS NULL THEN 'No' WHEN wiq.KeepAlive IS NULL THEN 'No' WHEN wiq.KeepAlive < dateadd(mi, - dbo.asi_GetWorkItemLockDuration(), getdate()) THEN 'No' ELSE 'Yes' END IsLocked
FROM    WorkItemQueue wiq
    LEFT OUTER JOIN ContactMain cm ON wiq.PerformerKey = cm.ContactKey
    LEFT OUTER JOIN Institute ins ON wiq.PerformerKey = ins.ContactKey
    LEFT OUTER JOIN ContactTypeRef ctr ON cm.ContactTypeKey = ctr.ContactTypeKey
    LEFT OUTER JOIN GroupMain gm ON wiq.PerformerKey = gm.GroupKey

GO